UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6LKkxpS9yEr2db+6nAQ3uenzNUyGCH0vj2u73ohrMcU='
WHERE
key_id = '47ebf3460c389bb9418f72586aec19f69bb099d8a59afb0a3e5537555697ae61'
AND (
token = '6LKkxpS9yEr2db+6nAQ3uenzNUyGCH0vj2u73ohrMcU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)