UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K38hoWlCiS1nUPullt2eUhLCi7o6Q4Ezb3pgNnn5bto='
WHERE
key_id = 'b7c493fe1c3423dad6755f29fe8d20e5b42b38eb30e29fa3c1f7d3fb3443f7bc'
AND (
token = 'K38hoWlCiS1nUPullt2eUhLCi7o6Q4Ezb3pgNnn5bto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)