UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HNskftnoZ+DRjGHYGXuzPyZ1M1D8UI+f/3maSkTnh04='
WHERE
key_id = '0b59902295da35d0ad103400ebb21339f098cd6ee304a54a58ba7b873c5bb1a0'
AND (
token = 'HNskftnoZ+DRjGHYGXuzPyZ1M1D8UI+f/3maSkTnh04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)