UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ONNbC8JghsHNC96bSHMr6bBSfbgAjrRXTAxNX7/eZMw='
WHERE
key_id = 'bcf3fe350094d1a7cce7e792f7d49a4c8908e4b59bebc71578ef6c973d3f7eb3'
AND (
token = 'ONNbC8JghsHNC96bSHMr6bBSfbgAjrRXTAxNX7/eZMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)