UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PGddZqhAFnk8gY7K+P0k3kO5F7oiT9EIo9CdB8I7uI0=' 
WHERE 
  key_id = 'a4f90d2c106c2c476ef134794e3a0e574139807cc9a2e092f4af8696cca38d7d' 
  AND (
    token = 'PGddZqhAFnk8gY7K+P0k3kO5F7oiT9EIo9CdB8I7uI0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037