UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SlmtvabpTJ/ctENSU8jemAP6kYq0croxjV+NyHZ4TFs='
WHERE
key_id = '1c1ac7fcd16876be596693b5435126c8cb0f6c070c907d7e79196527ec08b408'
AND (
token = 'SlmtvabpTJ/ctENSU8jemAP6kYq0croxjV+NyHZ4TFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)