UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sMf5A3oS8JF0Foycwp/WzRPW4WwGPR/XOHKM0CKsVQc='
WHERE
key_id = '000a88afcfa6983ddeabcbaf3d6215e526d27b8905156e0eb2640c9954689c28'
AND (
token = 'sMf5A3oS8JF0Foycwp/WzRPW4WwGPR/XOHKM0CKsVQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)