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