UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2Kss7qpx6jrZdnScVAJoZ4nnBYb1MImI4tUJ5rZoOZ0='
WHERE
key_id = 'd8a44b6ccb1de2632ca8ef0e296e391d850f1ca69476953ca7c35c9f0d012d2e'
AND (
token = '2Kss7qpx6jrZdnScVAJoZ4nnBYb1MImI4tUJ5rZoOZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)