UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sKWNs9r3Vb7G2i16/Wcr6x0wgt49IVSUHAZaKlB6/pE='
WHERE
key_id = 'e464eb856c22c063a45df52e59a6fe7ce957ea1920289470c12f7d96b4276950'
AND (
token = 'sKWNs9r3Vb7G2i16/Wcr6x0wgt49IVSUHAZaKlB6/pE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)