UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cdk5IILm4T8oQUbpQoE1mztqOZtWNdJO6p3lIIPEdKc='
WHERE
key_id = '87c4866b1155e69d93938a7ba5919f57182dfd63b2aa9b9a78053cb73e5667d5'
AND (
token = 'cdk5IILm4T8oQUbpQoE1mztqOZtWNdJO6p3lIIPEdKc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)