UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pE4TeQn6CvJjY08DoUw81G6PnCJAIhtUrYm+vlfSQFE='
WHERE
key_id = '31edb928a06c88ba3027d99da82532770911ebabe994b7120197badc80a5d46a'
AND (
token = 'pE4TeQn6CvJjY08DoUw81G6PnCJAIhtUrYm+vlfSQFE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)