UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DTjTs6qw+APF6BVdoKQFC8pG6al3l3MZ4aXBdel5edQ=' 
WHERE 
  key_id = 'aaf6cd2463ec4f7c8b30b8d973d91d2a4ce22455cf4b096c38d616245014e4c5' 
  AND (
    token = 'DTjTs6qw+APF6BVdoKQFC8pG6al3l3MZ4aXBdel5edQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039