UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9NeWx4KfHoGUJZt7cQ95RSln8FdyMpYo8huy5FX509c='
WHERE
key_id = 'd485ce4dcfe5f2310b4b508bd34d0259e9ccd40789b9fa8b637911b0927b333d'
AND (
token = '9NeWx4KfHoGUJZt7cQ95RSln8FdyMpYo8huy5FX509c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)