UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P4XS9dYCyZEYPyfAPi58RtDNyFLWPu4vkHIDXDgI010='
WHERE
key_id = 'c7c3747888f72ac628e0324c2497e9d3de4caba27c48d7baf8ef3447af4505a5'
AND (
token = 'P4XS9dYCyZEYPyfAPi58RtDNyFLWPu4vkHIDXDgI010='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)