UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gX8JVNS7Op3k8NfOV3OT7SJFWn9Zu4BEXo3hUwM3MVU='
WHERE
key_id = '9e1edd6fd132cec6e8c9efaf86324c18a1beda349dae95260f91a5575821be53'
AND (
token = 'gX8JVNS7Op3k8NfOV3OT7SJFWn9Zu4BEXo3hUwM3MVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)