UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'risZaobdNGZkJVZ5XyQyHzqFL/fVRUmB3eQYdp5bcMA='
WHERE
key_id = '1e8c83de7379a835625b1f89cb7a5f559b48ffc6712b0d30a6518a484799162f'
AND (
token = 'risZaobdNGZkJVZ5XyQyHzqFL/fVRUmB3eQYdp5bcMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)