UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZKN5WGCxL8T1GRi00+w5ZbXzcRqacmt/8D6B/IE2xRA='
WHERE
key_id = 'dcd9d178a487b89b1486ef7a5d01ea6c5970d8b872e92639679393ede54dd372'
AND (
token = 'ZKN5WGCxL8T1GRi00+w5ZbXzcRqacmt/8D6B/IE2xRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)