UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TVrZqvBdOwlu2+9LQf18eKlvt4KKeUZq5QRxwi3KTYs='
WHERE
key_id = '267bcc31cadad72a59aa47e9219de4f2224c5e9fa313934c44e823a28d42a3e5'
AND (
token = 'TVrZqvBdOwlu2+9LQf18eKlvt4KKeUZq5QRxwi3KTYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)