UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oLj7WW5uT3rjDZ42hv451W6qk7khZruKve1ZleYYeT8='
WHERE
key_id = '1e68613fb5b5623e22b4488422aa69867ce3617c7c7aa96dcd05dece0355a1a6'
AND (
token = 'oLj7WW5uT3rjDZ42hv451W6qk7khZruKve1ZleYYeT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)