UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OdRWO9z3uVYNkfasGjHEPppjiLqzKGDPmEgLwb7lQyA='
WHERE
key_id = '3d59ea709d0bd6a776925f66aab49d62aaa427c9644eba5b19fa890643f680a2'
AND (
token = 'OdRWO9z3uVYNkfasGjHEPppjiLqzKGDPmEgLwb7lQyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)