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