UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bW8gJHvcxeHjPIVf7Tzk6Jh4EjusBR4w0gjTmsX/HIk='
WHERE
key_id = 'dab200da3e65c3c7f6835f5ae3d7301f91af3787161afcc8a672f0550cf18613'
AND (
token = 'bW8gJHvcxeHjPIVf7Tzk6Jh4EjusBR4w0gjTmsX/HIk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)