UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LHL1JZK9eZTJSsIS9ProCvt+bpR2KWV6tpejVSdJfkM='
WHERE
key_id = '232170f67d842eb7cf0ea95c01892d87c6525a34204b0c278df21cbd55dba215'
AND (
token = 'LHL1JZK9eZTJSsIS9ProCvt+bpR2KWV6tpejVSdJfkM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)