UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7woQP5qAxxyVUYKtd8BR4y6sk07m22o5tyuv5+DlVj0='
WHERE
key_id = '99c886bd4c4b31cc29b13a2fc60ad6601de877557e5edfa0e1466dcc577645f2'
AND (
token = '7woQP5qAxxyVUYKtd8BR4y6sk07m22o5tyuv5+DlVj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)