UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vqW4SrbTs1cNuWyohjWd+NZ6vFbVtkfI07+JrHmISo8='
WHERE
key_id = '802bdf20b0354717583a960562a4028c3ad451c3991d57b83302a788252cfca3'
AND (
token = 'vqW4SrbTs1cNuWyohjWd+NZ6vFbVtkfI07+JrHmISo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)