UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xHCx6V5OYkdHNRBmS3BlTFgg8yJaNbwJPOanPKP9wTk='
WHERE
key_id = '060c16636be0e7ae3b4f2b4b4135b17a8eed09bad1c38798589563d0891d3bdf'
AND (
token = 'xHCx6V5OYkdHNRBmS3BlTFgg8yJaNbwJPOanPKP9wTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)