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